﻿CREATE TABLE [dbo].[Subscription]
(
	[sId] INT IDENTITY(1,1)  NOT NULL PRIMARY KEY, 
    [stId] INT NOT NULL FOREIGN KEY REFERENCES SUBSCRIPTIONTYPE(STID), 
    [carId] INT NOT NULL, 
    [batteryId] INT NOT NULL FOREIGN KEY REFERENCES BATTERY(BATTERYID), 
    [cId] INT NOT NULL FOREIGN KEY REFERENCES CUSTOMER(CID), 
    [cmId] INT NOT NULL FOREIGN KEY REFERENCES CARMODEL(CMID)
)
